CREATE DATABASE ClientCache
GO

USE ClientCache
GO

DROP TABLE tbl_file
GO

CREATE TABLE tbl_file
(
    uid_id          UNIQUEIDENTIFIER NOT NULL,
    vb_data         VARBINARY(MAX)   NOT NULL,
    vc_content_type VARCHAR(128)     NOT NULL,
    nvc_file_name   NVARCHAR(128)    NOT NULL,
    dt_created      DATETIME         NOT NULL,
    dt_modified     DATETIME         NOT NULL
)
GO

ALTER TABLE tbl_file
    ADD CONSTRAINT pk_tbl_file
    PRIMARY KEY (uid_id)
GO